Sage 300

Hello Everyone, We are experimenting with the Web API in Sage and I noticed that for OE Invoices it only allows GET operations. Is there a road map for the development of the Web API from Sage or are there any plans to implement POST operations for…

I keep getting error which prevent importing of Invoice Batch created using in Excel 2007 template. "The document total amount does not match payment schedule amount. Correct 05:15:30 payment amounts in the schedule". I have populated all necessary columns…

I am trying to process invoices and receipts in Accounts Receivable for a National Account (main account and not a member account), but I get the error that " Customer number XXXX does not exist ". I was under the impression that this is possible and…

Hello, Which is the correct procedure of comparing current Inventory value with General ledger? Item valuation by ''Transaction cost'' is matching with GL. But, ''Location details cost'' not matching with GL.

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 apply open credits e.g. prepayments, open credit notes etc directly to an Invoice in A/R while entering the Invoice. The Invoice amount should reduce with the credits amount.

I am able to import misc receipts into Sage 300 AR successfully. I create a batch, set my bank and batch date which equals my deposit date, then import a single file of multiple misc receipts to reflect that day of deposits. My question is that I have…

Hello Team, I need your help with the following question. I applied a payment for the Invoice, but the Invoice doesn't change the Amount Due. Could you please clarify why Sage 300 doesn't change the amount once the user paid the invoice using a payment…

I am from Vancouver BC area. We pay 7% PST on expenses. I am trying to enable tax calculations on our Sage 300 which are currently disabled on our AP System. When I do that, system is posting expense and applicable tax as two separate line items in the…

Hello Team, Could you help me with the following question. What Invoice field I can consider as an Invoice Close Date? I found only the Invoice Batch Date and Invoice Posting Date. But I cannot find the Invoice Close Date?

Can Sage300 order entry be prevented from copying the unshipped lines of an order onto the shipment and thence to the invoice tables, while still retaining backorder quantities on the orders? We have a situation where each order includes many products…

Am trying to import misc payment in AP Payment batch but all misc payment amount is duplicated Am using Sage 300 Standard 2020 PU 5

I receipted my purchase order and posted it in Sage 300 but I did not put the correct amount down and hence I cannot Invoice it. Is there a way for me to edit or delete the the receipt for the purchase order. Please help me ASAP. Thank you.

I had a check deposited in Feb and returned back in March my question is.. can I Reverse transactions in March the date the check was returned? I don’t want the bank to be effect for February it has been reconciled and posted. thank you newbie here!

I was wondering if anyone else has an issue with the A/R Document Inquiry Screen including Tax as part of the Detail and Total Amounts? We are still using 2018 PU3 Classic, has this been corrected in a later release or in the web screens? It seems…

Hi All, so one of my customer have done a wrong OE transaction, shipment, and invoice. They apply the wrong unit price, and this happen to a lot of transactions (4 days transaction) Is it possible to delete it, and delete it in a bulk? Thank you…

Sage 300 v2020 PU4 on AWS cloud Server ll works fine on the desktop version, however, when trying to create a batch entry within the Web Screens in AR Invoice it hangs and does not add an entry, it allows navigation to other modules and adding batch…

Hi All, My colleague, who somehow believes slowly entering the entries manually is the best way to do things, told me if I import entries from excel templates something is going to be wrong. Is there any truth to it? In particular, he mentioned that…

Does anyone know if there is a maximum number of shipments that can be on a single invoice, or maximum number of lines on a shipment.?

Hello Everyone! I'm working on the creation of an import file for posting AP Invoices, and the client has provided me with examples that are Text file types. I've done this before, but used CSV format for the import files. I'm wondering if it's as…

Is it possible to process an AP batch in October if the previous month (September) isn't closed yet? Would processing in October affect the September AP?

Client with the configuration above is reporting an issue in the Sage 300 Order Entry (Not Web based) The error is: "Unknown RSCID used in CRMReportOrder. (1158 oeordg1.CPP)." "Posting failed. You must enter the shipment again" This happened…

Hello, Is there a way to record individual credit card expense transactions and be able to reconcile the monthly credit card statements like a bank account? Or import the invoice #s for reconciliation? We have hundreds of credit card transactions…

I have a couple of duplicate A/R Receipts that cannot be posted because the invoice is fully paid. I attempted to delete the receipt, but I get a message that it cannot be deleted since it is a credit card payment that has already been processed by PAYA…

When the user is login and the Task Scheduler fired up, the posting in SAGE is successful. But when the user is Signed Out and Task Scheduler fire up. We received an error: Error: External component has thrown an exception.. Inner: . Full: System…