OE Select Code Question

[vbajock]

When I ran an Access query on the Order Line Item table for all line items with a Select Code of "S", the data that came back had all Order Type "O" items Qty Ordered as negative numbers and all type "C" orders as Qty Ordered as positive numbers. Does Macola reverse the sign when the orders are selected for billing or have I got something wrong going on?

 

[vbajock]

Ok, I figured this out. Apparently if the client is using the RMA add on it creates a + - qty for the same item for some reason.

 

[MacolaHelp]

Depending on whether you elect to reship or return or replace waiting for return, you might see these conditions in RMA processing.

All macola C type orders have the qty stored as positive numbers. If you want to report against or use information in credit memos, you must reverse the qty ord or shipped x unit price or cost to get the correct output. Macola's cobol logic apparently recognizes the differences between O orders & C orders & handles correctly in cobol reports or ICRs in the OE module. AR credit memos are a different animal. AR credit memos have the sign reversed on the edit reports in 7.6.100a but create the correct GL entries. I haven't looked to see what's in actual file, nor have I had time to report this feature yet . . .