• Inventory transfer macro is failing when negative levels allowed

    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…
  • Identify Account Segment from PO Transaction

    I need your advise on how to use account segment (identification of account segment) even from PO. Let’s make example, a PO was created from Segment Division of 100 (Fakultas Kedokteran). What I wanted is when I receipt goods, the Journal will be Dr Inventory…
  • How to fetch ICItem inventory details location or warehouse wise in webapi?

    Hi Expert I am middle of a prodect and i am getting stucked. I need to fetch inventory details location or warehouse wise in webapi. In the following way, I am using Request url xxxxxxxx/.../ICItems eq '*KL-ST1-R*' I want the inventory details…
  • Purchase Order Clearing Account Reconciliation

    Using Sage 300 Premium 2018, with Purchasing and Inventory Control modules. The PO Clearing account on the balance sheet has no means of reconciliation or audit report that proves the GL. I need a report that shows PO receipts that reconciles to the…
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    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…
  • Import I/C Adjustments

    Can someone please advise (or provide) where can I find a Template, instructions and key for I/C Adjustments? We are using the Export/Import capabilities as often as possible and I can usually find what I need by exporting a previous item and recreating…
  • Inventory "Seasonal" Items

    I would like to know what happens when you check the tickbox that says "Seasonal" in the inventory items. Anyone know what the consequence's are?
  • API endpoints

    Hi, I am trying to fetch product prices and product inventory, but couldn't find any which does the job. So, can you suggest me the suitable endpoints to fetch Item price and Item inventory?
  • How to updating Physical Inventory in Sage 300

    I'm a new user of Sage 300 I wanna Update my physical inventory because he's different with what I have on hand, so when is connect to the POS (Orion POS) I'm using the data are different to what I have on hand sometimes I can't even sell some Items.…
  • Is there any way to add more than 10 IC segments?

    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…