Import Orders Changes the Transaction Category from the Import Table

Issue

Importing sales order changes the transaction category defined in the import table to default values. The same values defined in the import table can be entered on the detail of an order so there is no reason to change the values when importing. This will post to incorrect postings to GL after shipping and invoicing.

Solution or Workaround

PTR 91450 has been entered and fixed in Pro 2011

Steps to Duplicate

1. In OE enter a new order for ADG1 and A2EW on the detail screen.
2. Change the transaction category to DEF SHP and save the order.
3. Create a header and a detail file from these records with a valid format to import from such as dbf, CVS, XLS
5. Create import table for Sales Orders from both the header and detail record and not that the detail still has the DEF SHP transaction category
6. Import Data for Sales Orders from the import table you created in prior steps. Notice that the detail of the import still has the DEF SHP transaction category.
7. Once the order has been imported edit the line for A2EW and notice that the transaction category has changed to DOM HRD.

© Copyright Sage Software

 

 

Leave A Comment?