Introduction
- Mappings and requirements for promoting ERP Purchase Order records to a Brill Least-Cost Formulation system via an export file.
- See also: Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
Mappings
| ERP | ALIAS | AAI | Brill | Default |
| POLine.POLineSeqno | PO Line Sequence # | PurchaseOrder_Stage.Sequence | ||
| POPurOrd.POSeqNo | PO Sequence # | PurchaseOrder_Stage.LineSequence | ||
| POPurOrd.divcd | Division Code | PurchaseOrder_Stage.DivisionCode | Plant Code | |
| POPurOrd.PurOrdNo | PO # | PurchaseOrder_Stage.OrderNumber | ||
| POPurOrd.podt | PO Date | PurchaseOrder_Stage.Date | ||
| Vendor.VendorSeqNo | PurchaseOrder_Stage.VendorID | |||
| Vendor.sname | Vendor # | PurchaseOrder_Stage.VendorCode | ||
| Vendor.name | Vendor Name | PurchaseOrder_Stage.VendorName | ||
| ItemMaster.invclscd | Inventory Type | PurchaseOrder_Stage.InventoryType | ||
| ItemMaster.itemcd | Item # | PurchaseOrder_Stage.SourceItemCode | Ingredient Code | |
| ItemMaster.desc | Item Description | PurchaseOrder_Stage.ItemDesc | ||
| POLine.totdelqty | Quantity | PurchaseOrder_Stage.Quantity | ||
| POLine.unitcst | Unit Cost | PurchaseOrder_Stage.Price | Current Cost* | |
| POLine.totdelqty * POLine.unitcst | Extended | PurchaseOrder_Stage.Extended | ||
| Record Type IP | ||||
| Previous Cost** | ||||
| Stock Status | ||||
| Add ON Base Cost |
* At this point, we do not know if we are multiplying this cost by 100 (hundred-weight conversion).
** We need confirmation that we are using the current cost for the price, or the previous cost field.
Validation
- x
File Formats and Examples:
- Brill File Format: Brill Ingredient Cost Export File format.pdf
- Extraction Criteria: AAI-27 - PO to Brill.msg