Sage 300

Since the T4A forms come from Payroll, has anyone figured out how to get the Vendor's business number in Box 13 of the form, since there is no place to add it in Payroll.

Intermittent. Job related PO Invoice for multiple receipts entered using drop down, the invoice appears to be OK but after day end the AP Invoices are split by receipt number with the same Inv#. This creates an Error batch in AP. V 2017 -PU6; cannot replicate…

During an end of month retrieve into SA the client is getting the following error message: [Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot insert duplicate key row in object 'dbo.UXARINVHO' with unique index 'UXARINVHO_idx0'. The duplicate…

Hello, As per subject, it pop-up error message and i have to manually delete off from my excel and continue import. I have 130k of new items and i do not wish to do the deletion part. Please help. Sage 300 2016 Advance PU 5.

We have a couple of optional fields set up in I/C on about 50K items that have not been used in years. Can't delete then because "they are in use" I want to clean this up and then set up one new valid optional field. Are there any ramifications…

Client receiving errors in posting status on worksheet. stocktake does get posted and adjustment batch posted. But on post reconciliation, status is Errors in Posting

A little background to start off with. We use Large Hydraulic Cylinders and track them using our I/c serial numbers module. When we take it off a truck to be rebuilt we assign it a COXXXXXXX (Core) item number. Once it is Rebuilt we adjust out the Core…

When trying to run out one of the canned reports in SA I am getting an error - "Failed to open the connection. PerCatBud. Details: [Database Vendor Code: 17 ]. Image of the error is included. Anybody have any suggestions? All other reports seem to be…

How do you copy an Order in Order Entry and have the Optional Fields also copy? It appears to me that you may add them, but that must be manually done. Is there a way to automatically have them come across?

What is the best way to use Purchase Orders for Asset and Expense Item purchases?

We have been using ACCPAC since the DOS days, at least since I started in 1994. Historically, we did a small amount of service and repair work, but the bulk of our business was distribution - simple in and out of product with no added value. In the…

The product has an odd number of quantity on S/O. There shouldn’t be any decimals in this field because all quantities listed in S/O should be for each.

Hi Support, we have faced a rather strange issue with one of our clients using sage 2018 PU2. The currency rates table is updated daily with exchange rates. However when a PO is raised for a foreign currency vendors, a different rate is picked and…

Good Day Please explain what criteria is used for determining which items get reflected on the re-order report. I am experiencing instances of item QOH below the minimum Qty but not showing on the report. What other factor is being evaluated ? Please…

What is the maximum number of lines that can be entered in requisition entry?

Hi All, There is a day end error of our client which displaying - Day end processing could not process all transactions. Their Installation is Sage 300 ERP 2017 - PU 5. We had done DB Dump, Load, Integrity Check with Fix minor errors, but it did not…

I understand how to set up discount terms in A/P, but when and how are they applied? In the PO Order Enty and Receipt Entry screens, in the table, the discount is not showing it is calculated against the line item. In the Terms Tab of the PO Invoice Entry…

I just installed Sage 300 V 2018 web screen and after I did update release 1 and 2 It doesn't allow to entry. Anyone know about this problems. Sithan

Hi Support, We have a client who used to use VM Service manager. which was linked to inventory and order entry. they have identified some items that have Qty committed to sale because of VM service manager. the items are old and need to be written…

We use different online marketplaces and they charge a commission/fee to us for selling products through their website. How can I build this into Order Entry, such that the commission/fee is included in the cost of order/item. Ex. debit inv/cogs, credit…

A credit card payment was entered, posted to the correct customer, but to the wrong invoice. Is there a way to fix this. We attempted to reverse the entry, but since it was made with Sage Payment Solutions this was not allowed.

When the terms are credit card all orders in order entry should be pre authorized. Is there a way to find orders that should have a pre authorization and do not?

If I enter an order in OE and enter a prepayment and post the order, when I later invoice the order the prepayment is not shown against the invoice, but only on the right hand side of the invoice totals as an order prepayment. If I enter the prepayment…

We are doing a bank rec and the amount of deposits outstanding is incorrect. When we take a look at the outstanding deposits they are only $13,000, but the report shows $41,000. The outstanding checks are correct. Any ideas?

How do I see the activity for miscellaneous freight charges in order entry? The only report I see just lists the set-up information for miscellaneous charges.