Sage 300

Hi there, I would like to create a budget report breakdown by month in columns side by side, what FR formula should I use for each column? Thanks, Zia

Customer Receipts are posted in the A/R as Prepayments because there is no Invoice. There is a plan on when and how much the Customer should pay. How can this Plan be managed in Sage 300 without raising an Invoice? An invoice is raised at the end…

Hello Team, To receive the currency rate I use the following endpoint -> CSCurrencyRates The response has the following structure: { "ToCurrency" : "CAD" , "RateType" : "AV" , "FromCurrency" : "AUD" , "RateDate" : "2020-01-02T00:00:00Z" ,…

I have chart of accounts with two segments i.e MAIN & MAIN SUB 1234 Repair and maintenance 1234-01 Repair and Maintenance - HQ 1234-02 Repair and Maintenance - TZ 1234-03 Repair and Maintenance - ZM On printing financial reports only Main…

Good day, Sage 300 2021 PU2 I have a new Irish entity to setup which will be my first time setting up an Irish/European entity. In looking at the VAT/Tax reporting requirements I was wondering if there were any samples out there of the Tax Services…

We have a client running 200 2021 with Product update 1. On the machine that is the main one (server), they get the above message when posting a combine Vendor request using Vendor Number Change. Anyone have any sugeestions as to how to proceed.

A company wishes to setup Sage 300 for their operations in 4 different countries, 4 different currencies all reporting back to a single currency. There are two options Option 1: 4 different Sage 300 Databases Option 2: 1 Sage 300 database with a entity…

Sage 300 2019 PU7 How can we move some posted transactions (Invoices, Debit/Credit Notes, Receipts etc) between Customers in Accounts Receivable. Break the Account move some and leave the rest. Without creating Debit/Credit notes.

I have a client, where for a couple of companies, I cannot export the customer or ship-to records. When I attempt to export my customers, the screen that shows the records, the first record should be customers, but it only shows a "-". If I look at attempting…

We have 2 deductions set up for Pension. One is for the Employee contribution, and one for the employer portion. Both are set to 5% (Percentage of Base). The employee portion is set to go to box 20 and 52, and the employer is set to go to 52 only. They…

We have a client that noticed that the entries she is doing in history to update hours for employees are not being reflected in box 15C of the ROE. They are using the latest payroll tax updates and running version 2020.

I have a client using Web Screens (V6.6) 1 of many users can't insert lines on an AR invoice in some companies. She can in one company, but can't in others. - I have checked permissions - all the same, I have tried logged in as ADMIN, and can't when she…

hello, i would like to reverse a credit note done on a previous month. how can i do that? thanks eblim

I have added a contract in the Contract Module and it has been approved. But when I go into the Billings module, it is not listed as an active contract. What step am I missing?

Sage 300 2019 PU 5 How to force a zero quantity in A/R Invoice using item detail type where the Invoice has an Extended Amount >0? Using summary detail type is not an option because there are other Items to be loaded on the same Invoice. Using Quantity…

My client has 3 databases on their Terminal Server, they also use Customisation Directories. \COMPANY-A\CUSTOM\GL66A\ENG \COMPANY-B\CUSTOM\GL66A\ENG \COMPANY-C\CUSTOM\GL66A\ENG When Printing Financial Statement using Print Financial Statement…

Hi Currently we are using Sage 300 2017 for AP,AR & GL for almost 3 years now. As for the Intercompany Transactions Module 6.4A already installed but not yet activate.. I have tried to activate by the below message pop up.. all batches already posted…

Why I export and import batch payment batch list as payment amount from older batch payment amount is double payment amount but in detail is not double double all entries in misc.payment. I inqured excel template is the same as old template. or…

Hi all, Have a customer that imports new vendors monthly with a Single CSV file created from another system. When I try to import after upgrading there is a new table for Vendor_Contact_Selection because multiple contacts have been activated. The Status…

Hi Am getting this error when adding or posting an AR Invoice batch in Sage 300. System error. Call to lnkCommitTrans failed [227] I recently did a database move using the dump and load. Now my AR batches dont want to post. What could be the…

I have a report that is pulling info for each my end of years. the .L1, etc works for every year when I use it with BALP, but it only works to L9 when using it with FRFISCAL. My formula is =@FRFISCAL("END","L9"). When I change the 9 to 10 I get the fiscal…

A number of invoices were added in may however some of the may invoice dates were dated Jan so it ended up in Jan. The invoices were reversed in the general ledger since there were already posted. when the ages trial balance was run for the customers…

my predecessor & I are preparing for my 1st YE. We were looking for a Vendor Ledger and can't seem to find where it could be located. Can anyone point me in the right direction? Please & Thank you...

Hello, While posting an invoice generated by the PO module, i'm receiving an error message in AP module. The error is not clear and is generic. "Error occurred during posting batch(es)". The receipt entry went through without any issues and I can see…

I have a client that just installed Sage 300 on a new workstation. Everything is working except for printing. When we attempt to preview a report it just goes blank. When we attempt to print a report the default printer is the old printer that is no longer…