Sage 300

I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2 I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5. Location 1 had zero of these items and so…

For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…

Hi, My report opens in Crystal but not in Sage - it tries to open, there is a quick glimpse (flashes on the screen) of it opening and then nothing. No error message. I tried creating reports from different tables - all with the same result. Any…

I designed a report based on ICITEM,ICREORD and ICILOC that gives reorder quantities and some calculated columns for a parameterized input of location and item segment (from segment and to segment). These are dynamic parameters. The report DOES NOT…

I don't need more than 10 segments for any one structure, but we have such a wide spread parts offering that I need more than 10 global segments to accomplish what I would like to. We are in the process of upgrading to Sage 300 and figuring out IC…

Hi, I have created several optional fields in Inventory Control to an Item. When I link the table ICITEMO to the Order Entry Lines by Item, I do not know how to pick the correct optional field from ICITEMO. I have 5 optional fields, but it seems to…