Sage 100

MAS 200 4.40.6. We have a client importing requisitions from a third party product (MARS) like Sage Inventory Advisor to Purchase Order. Inventory product lines are set to post by warehouse. MARS is including the correct warehouse code with the data. We are importing the warehouse code and are file assigning the GL account number from the product line file. The import works well and the data in the import log looks fine; however, the import is failing to adjust the GL account number by the warehouse segment. Has anyone seen this issue before? Is it possible for MAS 200 to handle this properly?

I have not seen this however, the ""post to"" warehouse GL account segment is a field (PostToGLSubAcct) in the IM_Warehouse table. You could bring this into a temp field and then concatenate it with the Product Line main GL segment(s).

An import to PO should not require a Product Line assignment as this will default from the Item. I would try assign the item (this should default a gl account and a warehouse code), GL Account (assuming the GL account is different than what is set up on the product line, otherwise this assignment will not be necessary at all), and Warehouse (should trigger the gl substitution) in that order. What happens when this is done manually?

Thanks for the suggestions. I will get back to this today. When a PO is created manually, it works as expected. @WilliamSchlageter, you are absolutely right. I am not sure why I mentioned Product line as we are not importing that. I corrected the original message above.