-
Dear Masters, I created a purchase order with 10 qty and posted and invoiced with out structure Next day I consumed that inventory for production out of 10 I consumed 6 . Two days later I found that I did not update structure . So I need to adjust that structure ( excise and Vat , ). Now I want raise...
-
Dear Masters, I created a purchase order with 10 qty and posted and invoiced with out structure Next day I consumed that inventory for production out of 10 I consumed 6 . Two days later I found that I did not update structure . So I need to adjust that structure ( excise and Vat , ). Now I want raise...
-
Hi In Company 1 is 1100 also referenced with 1000? In the master DB do you need to see 1000 referenced as C1 - 1100, C1 - 11100? I am presuming you are "creating" a master DB, therefore do you know which company is the "master"? Just be careful not to overwrite an existing record...
-
I am designing a database wherein data from 3 companies will be included. Data will be imported using standard dataports. RETAIL operations using barcodes and Item Nos. We will be only importing the cumulative sales / purchase value / inventory for the month into the central db. Issues: The companies...
-
John, pretty good idea. Post data import, the item cross-ref table can be queried in order for the master item no and then the data can be actual posted I have given it a try and it works fine
-
Can you use the item cross-reference table in the Central DB to reference all possible alternate numbers from the other companies?