Browse By Tags

  • 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

  • AutoGenerate from Sales Orders Does Not Copy Item Comments from DropShip Lines

    Hello, We have comments on sales order dropship lines that we would like copied to automatically generated purchase orders, if possible. We are unsure how to accomplish this. Is it possible to transfer sales order line item comments to dropship purchase…

  • 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…

  • creating PO invoice using RESTful API

    How do I create a PO invoice via the RESTful API? There are only GET methods when trying to overcome this by creating an invoice using AP/APInvoiceBatches in the body of the request in the field "SourceApplication" I've given the value "PO" this isn…

  • Item Code Setup

    In Item Code Maintenance where you set up the units of measure. What is "SALES" used for? Is it used for sales to an end user, or is it used for the recipes/bill of materials/costed bill sales?

  • VI job for PO receipt of goods - T Record Invalid or Write Failed

    I've been working on a VI Import job for PO receipt of goods, serialized items. I think I am close, but I am running into this error: T Record Invalid or Write Failed. I've scoured the net, Sage City, Knowledgebase for a solution but no luck. Does anyone…

  • Reopen a Completed PO

    Is there a way to allow non-Admin Sage 100 users the ability to Re-Open Completed PO's? Quite often we get late Invoices or additional quantity received after the PO has automatically been changed to Completed status, due to 10% Completion rule or that…

  • Sage300 PO Y/N optional field. Value not changing.

    Hey Everyone, I am new to Sage 300 and crystal reports but have a decent handle on both. We recently implemented a yes/no optional field for PO line details, everything tested fine for a few days but now it seems like the value remains as 1 no matter…

  • When raising a PO, have a column for N/C so that this can be amended easily.

    When raising a new purchase order, it would be really helpful to be able to add a column for nominal code, for each item. This would enable the ability to quickly check that each item has the correct nominal code, and amend as required, rather than having…

  • Can we use VI to place/drop a standard PO that pulls balance from a master PO?

    Hi, We have a lot of master PO's that suppliers ship partials in multiple shipments. Hence we assign a letter to a standard PO for each shipments using the same master PO #. The standard PO draws balance from the master PO (Master/Repeat PO). We are…

  • Sage 50 Purchase Order Journal Import Question

    Is it possible to add line items to existing Purchase Orders through Sage 50 Accounting Software's built in import tool? I can import multiple line items upon the initial upload but I cannot seem to figure out a way to add a line item to existing POs…

  • Stock Item PO comment

    Ability to add a PO comment on the stock record that shows on PO's, much like the picking and despatch comments on the stock record

  • 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…

  • generating a PO from a sales order

    I would like to know if it is possible to only create Po's from a sales order for items we don't have in inventory? If I create a sales order that has lets say three items two that I can pull from our inventory and one that I don't have any in stock…

  • Does anyone use Agora Systems for purchasing?

    Hi folks, We have been searching for purchasing software that integrates with Sage 300 CRE for quite some time and it looks like Agora Systems may be a good fit for us. We don't currently use the purchasing module; we manually verify POs and enter everything…

  • Sage 300 web screen "An unexpected error has occurred. Please try again or contact your administrator for assistance." When opening any Purchase Orders Screen

    Problem: Error when opening PO screens Web screen Cause: Inadequate User Rights Resolution: In the Administrative services-Security Groups ensure that the Sage 300 Web API is selected and that these rights are allocated to the USERID for the…

  • PO Daily Receipt Registers posting VERY (!) slow

    Sage 100c Advanced 2018 v6.00.10.0 When we update a Receipt of Good Register, even for just a small receipt, it can take 30 minutes or more to update. No other updates in the system take as long Is there a way to refresh the work/crystal files so…

  • Sage 100 2018 Customizer question PO Receipt of Goods Date UDF to post thru to IM Cost file

    Sage 100 2018 Customizer question All Inventory items are FIFO Valuation Client wants a Date UDF added to the PO Receipt of Good Lines I added the Date UDF to the PO Receipt of Good grid I need to know the steps on how to get this Date UDF to post thru…

  • Vendor Details

    My SAGE 300 is setup the way every time we enter receipt it will update vendor cost in Vendor Details. In general this is fine but lately we experiencing problem where PO’s are delivered after 3-4 moths and price is changing frequently, so old PO will…

  • Best AP Automation tool that works with Sage 300

    What is the best AP Automation tool that works with Sage 300 that has PO creations

  • Link PO to SO

    Being able to link a Purchase Order to a Sales ORder would be great. We often have to purchase goods in for specific customers, but it is often difficult to match the PO to the SO.

  • ROG - Answering Yes to "Do you want to receive the complete purchase order?" blanks out Item Code with UDFs

    I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…

  • Having a Master PO, how to assign a derivate PO to a different phases?

    As soon as you hit new order to draw quantities, Phase option is disabled. Unless you assign the Master PO to a Phase, but that's not practical.

  • PO wont display amount

    When I print my PO to PDF the amount is displayed by #### symbols. Is this a formatting error? I attached a snapshot of what it looks like. Thanks!

*Community Hub is the new name for Sage City