x Want to participate? Join the group to interact

  • Sales Order To PO Address and lines button script

    Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

  • Vendor Pricing Method Field

    In Vendor Pricing Maint. there is field called "Pricing Method" What table is this field in and what is the field name under the covers? Thanks

  • PO Receipt of Goods - Receiving existing line and adding new line not writing new line quantity

    I have a PO that I am receiving against. I want to receive part of the line that exists as well as add a new line. The existing line is received as expected. However, when I try to add the new line, it creates a line with the item code and unit cost…

  • Access PO_ReceiptReturnMatRqByPO

    How can I access the table object PO_ReceiptReturnMatRqByPO? I need to delete a record from this table which refers to a ghost receipt and locks my PO. There isn't a file with _bus or _svc, so using NewObject returns "NewObject Error 90". When I…

  • Get PurchaseOrder and Lineitems

    How to get PurchaseOrderNo using PurchaseOrder Details & LineItems data from Sage 100 desktop application using C#? I have using DispatchObject and done login and select company functionality. Can you please help me to get PO detail using C#?

  • Sage 100 : PO with custom Charge LineItem is missing in Receipt of Goods

    Hi, I have a query on PO and Receiving module. When a charge/expense line item is created in PurchaseOrder and a Receipt of Goods is created against it, those lines are not adopted in receiving. However when I manually add a new charge Receipt of…

  • PO for Inventory but was paid with credit card

    A PO was issued for inventory items. There were received and have been paid with a credit card. How do I clear the PO? I need to invoice something so the PO closes. I can't invoice it, since I've already paid for it with a credit card. Thanks! …

  • Pricing Updates for Inventory Items

    We are having trouble updating pricing. We are updating in the Item Maintenance module, the Purchase Cost and Retail cost. These updated costs are not pulling into Purchase Orders and Sales Orders. Any ideas?

  • Script Access to Current PO# in PO Header table

    I have searched Sage City and cannot see to find this. I would like to fill the current PO # on the comment line as a default when creating a new PO. I have added script to default warehouse based on current user, but cannot seem to find how to access…

  • RE: <Error: 0 in Method GetValue>

    80020009 Same problem here - SO and PO modules. Upgrading from Sage MAS 200 4.40.0.5 to MAS 100 2013 5.00.7.0. Tried on XP, Windows 7 (cmd as 32-bit), Windows 2012 Server Standard (cmd as 32-bit) support.microsoft.com/.../896456 (%windir%\SysWoW64…

  • Trying to use BOI to create PO, issue with Vendor Number

    Greetings, I am trying to use the following: retVAL = oPOOrder.nSetKeyValue("PurchaseOrderNo$", sPONumber) retVAL = oPOOrder.nSetKey() retVAL = oPOOrder.nSetValue("PurchaseOrderDate$", "20140529") retVAL = oPOOrder.nSetValue("OrderType$", "S") retVAL…

*Community Hub is the new name for Sage City