• VBA macro for Order Entry price not on price list

    I am trying to get my macro to allow entering a price manually. The price is not on the customers assigned price list, nor on any other price list. It is essentially a price override, which we are able to do in the UI. Get the following warning 'Information…
  • Web API - Sage 300 2020 - ARReceiptAndAdjustmentBatches

    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…
  • AP entry - How to deny continuation of entry if year is wrong?

    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…
  • Requisition Entry Document Number not updating

    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…
  • Unable to post via Task Scheduler - System.Runtime.InteropServices.COMException (0x80004005)

    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…
  • AP control account YE error batch

    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…
  • When is Posting In Progress really posting and when it is stuck?

    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…
  • Import shipment status processed

    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…
  • Macro runs only when user is ADMIN

    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?
  • Inserting tax amount using macro

    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. …
  • PJC - copy material details to new project in same contract

    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.
  • Changing number of fiscal periods from 12 to 13

    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…