Sage 300

Hello everyone, I am new to Sage 300 for payroll. And I entered Probation when create the new hire files under payroll-Class-Schd tab, so the Probation status will show on the Pre-Cheque Payroll Register. But now I would like to clear the Probation status…

I may not be processing this correctly. Send the request below creates a new batch everytime. POST: http://localhost / Sage300WebApi/v1.0/-/TESTCOM/AR/ARReceiptAndAdjustmentBatches { "BatchRecordType" : "CA" , "BatchNumber" : 100 , "BatchType…

Hi All Why my Qty On Hand at IC Location Detail different with ICILOC.QTYONHAND? any solutions?

Sometimes clerk uses the wrong year, or month, when entering AP invoice. We post automaticall;y to GL She doesn't check her report for errors and then controller needs to investigate when it is denied posting at GL level. Does anyone know of a way…

I need to recalculate AR debtor balances for my aging report comparison. Which tables should I use and which fields will help me identity the amount due?, I will greatly appreciate your help.

I have a client that user Sage Inventory Advisor and it has not been updated since last Thursday. When they attempt to refresh the entire database nothing happens.

I have a client that replaced their workstation and now they are unable to run the Work Force Analyzer. We installed the latest updates of Sage 300 payroll and the Work Force Analyzer, but when they launch the program we see a message Connecting to Sage…

Wondering if anyone has seen a third party app or customization which allows you to allocate/prorate inventory against quantities ordered. We would like to adjust quantities ordered on orders, based on inventory available in an on screen batch format…

Sage 300 ERP is concurrent user license model. Is is possible to have named user license concept? There is a challenge where there are some lite users consume lanpaks for the whole day. This effects other busy users from login. Is there any solution…

Hi, From 2 workstations, users are making PO Requisition Entry, Document number is auto-generated as per settings, both users not entering anything in ***NEW*** But time to time, we get error saying "document number already exist" and find that next…

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…

Deleted AP "Cannot post to a future year" error batch generated by the system (though a new fiscal year was already open). The entry was generated when cheque payment was posted. Now, AP subledger doesn't balance with GL. What is the best solution…

How can I get the Moving Average Cost of an Item from the SQL database? Is this value stored anywhere, or must I calculate it?

The existing formula for the field is this. ToText({OEINPR3.QTYORDERED},toNumber({?QTYDEC})). It rounds the quantity to a whole number. I need to decimal places. Thank you

I have no problem recording a macro that does a Bank Entry. However, when I record a Reverse Bank Transaction, there is no resulting VB code. Does anyone know how to do a Reverse Bank Transaction programmatically?

I've got a half dozen macros that are creating and posting receipt batches. Iciniti is also creating receipt batches and posting them. Occasionally I get a posting conflict trying to post two batches at the same time. One batch is left with the Post In…

Dear all I have a customer who has received 16 goods intstead of 32 and inserted the invoice number.. after running the day and processing, he realizes that he was supposed to receive all 32 quantities... what do i do please help

Hi I'm importing shipments and the status is "Shipments: 0 updated, 0 inserted, 1 processed". The shipment is not imported I can't find it anywhere. I tested the whole process on a test company and there it imports perfectly. I don't understand why…

I have an unapplied receipt showing as -ve receivable in my AR Sub Léger, how can I go about correcting this? The AR ledger looks okay. Thanks

Please contact me if you are interested in partnering up. We've been a Sage VAR on the east coast since 2006, and are looking to add more VBA and macro experts to our team. Thanks very much! Kellie Pitt, ERP Practice Manager Brainsell Technologies…

A client created two macros but 1 macro will only run when the user running it is the ADMIN user. I know I saw this issue about 5 years ago but I don't remember how we solved it. Any ideas?

Hi, I am in the midst of importing data into AP Credit Note using a macro and trying to bring in the tax as 'Enter' and not 'Calculate'. I could do it with AP Invoice without changing the AP setup options but I cannot do it with AP Credit Note. …

Hi All, Is it possible to copy materials from existing project to a new project in same contract in the contract management screen? Thanks in advance.

During a support call with a customer yesterday, I saw that he had changed the number of fiscal periods from 12 to 13 for the current year (beginning 4/1/15). Other than the obvious problem doing year on year comparisons, will this break anything? We…