Managerul de magazin comandă marfă
Data mapping
The suppliers for a product are distinct for each facility. There is a party for each Facility. Suppliers are stored in mantle.product.ProductPrice, using the following fields:
- productPriceId: supplierId+"_"+productId+"_"+facilityPartyId
- productId: productId
- vendorPartyId: supplierId
- customerPartyId: facilityPartyId
- priceTypeEnumId: "PptCurrent"
- pricePurposeEnumId: "PppPurchase"
- price: price
- priceUomId: "RON"
- preferredOrderEnumId: "SpoMain" or "SpoAlternate"
- otherPartyItemId: supplierProductId
- otherPartyItemName: supplierProductName
Product Pareto category is stored as:
mantle.product.category.ProductCategoryMember
- productCategoryId: facilityPartyId+paretoCategory (eg.: L2A)
- productId: productId
mantle.product.category.ProductCategory
- productCategoryId: facilityPartyId+paretoCategory (eg.: L2A)
- productCategoryTypeEnumId: PctPareto
- categoryName: "Colibri Pareto A"
- ownerPartyId: L2
Products that should be kept in stock and replenished when sold are stored as:
mantle.product.Product
- requireInventory: Y or null
mantle.facility.ProductFacility:
- productId: productId
- facilityId: facilityId
- minimumStock: minimumStock
Product ordering requirements are stored as:
mantle.request.requirement.Requirement
- requirementTypeEnumId: RqTpInventory
- statusId: statusId
- facilityId: facilityId ?: ec.user.getPreference('FacilityActive') ?: ec.user.getPreference('FacilityGeneralDefault')
- productId: productId
- quantity: quantity
- description: supplier.organizationName
Screen outline
Necesar
- search widgets
- table
- cod
- denumire
- UM
- pareto
- ultimul preț achiziție fără TVA
- preț vânzare
- furnizori
- stocAchCuTVA (hidden)
- DIO(zile epuizare stoc) (hidden)
- stocAchCuTVA * DIO (hidden)
- stocMinim
- stoc L1
- stoc L2
- comanda recomandată L2
- comenzi furnizor L2
- adauga
- refresh button
Aproba
- search widgets
- Comanda
- Delete
- table
- Cod
- Denumire
- UM
- ULPfTVA
- preț vânzare
- Furnizori
- Necesar
- Comanda popup
- furnizor
- trimite pe
Comenzi
- search widgets
- Delete
- table
- Cod
- Denumire
- UM
- Furnizor
- Comandat
Screen data mapping
Necesar
| Table | Products WHERE Product.ACTIV_FIELD = true AND Product.HIDE_WHEN_ORDERING_FIELD = false mantle.product.ProductPrices WHERE requireInventory = Y/null AND customerPartyId = this gestiune partyId(L2) AND priceTypeEnumId = PptCurrent AND pricePurposeEnumId = PppPurchase |
| cod | Product.BARCODE_FIELD |
| denumire | Product.NAME_FIELD |
| UM | Product.UOM_FIELD |
|
Pareto |
mantle.product.category.ProductCategoryMember.productCategoryId |
| ultimul preț achiziție fără TVA | Product.LAST_BUYING_PRICE_FIELD |
| preț vânzare | Product.PRICE_FIELD |
|
furnizori |
Organization.organizationName from ProductPrice.vendorPartyId WHERE preferredOrderEnumId = SpoMain |
| stocAchCuTVA | product.stocLX * lastBuyingPriceWithVAT |
| DIO |
stocAchCuTVA / dailyCogs dailyCogs = (Product.getTotalSalesPeUltimulAn - Product.getTotalProfitPeUltimulAn) / 250(zile lucratoare in an) |
| stocMinim |
PF.minimumStock ProductFacility PF where PF.facilityId = gest.id AND PF.productId = product.id |
| For each gestiune | |
| stoc gest.getImportName | p.stoc(gest) |
| comanda recomandată L2 | PF.minimumStock-p.stoc(gest) ?. p.recommendedOrder(gest) |
| comenzi furnizor L2 |
SUM(R.quantity) mantle.request.requirement.Requirements R WHERE R.productId = product.id |
| adauga | new Requirement with statusId = RqmtStCreated |
Aproba
| Table |
Requirements R WHERE R.statusId = RqmtStCreated AND R.facilityId = L2 |
| Cod | P.BARCODE_FIELD |
| Denumire | P.NAME_FIELD |
| UM | P.UOM_FIELD |
| ULPfTVA | P.LAST_BUYING_PRICE_FIELD |
| preț vânzare | P.PRICE_FIELD |
| Furnizori |
Organization.organizationNames from PP.vendorPartyId |
| Necesar | R.quantity |
| Comanda popup |
Selected rows R |
| furnizor(S) | Auto select most common supplier from selected rows |
| trimite pe |
Update on Supplier change |
Comenzi
| Table |
Requirements R WHERE R.statusId = RqmtStOrdered AND R.facilityId = L2 |
| Cod | P.BARCODE_FIELD |
| Denumire | P.NAME_FIELD |
| UM | P.UOM_FIELD |
| Furnizor | R.description |
| Comandat | R.quantity |