Browse By Tags

  • Data Validation Error 115 SO Detail

    Hello Does anyone know what the root cause of this break between the SO and PO Lines. Since we upgraded to 2022 version (Sage 100 Advanced 2022 7.10.2.03 64 bit) This scenario has occurred on a frequent basis. I know how to correct it; however, we would…
  • 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…
  • I have used Sage for 30 years and need to utilize purchase order and inventory modules.

    Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.
  • Sales Order and Purchase Order batch changes

    Batch changes on the sales order and purchase order modules would be helpful for applying the same consignment number and courier selection to multiple orders. Quite often it is the case that multiple sales orders for the same customer are despatched…
  • Convert an order into a sales order, delivery note or invoice.

    Very often I place a complete purchase order which is for a specific customer and I then have to invoice the complete order when it has arrived. It can be very tiresome duplicating this into an invoice especially with multiple stock codes and then adding…
  • Purchase order partly invoiced (Sales order partly invoiced)

    Good day, We never receive all the items ordered in one go and as a result, we invoice the items as they are received. Is there a way to delete items that are partly invoiced on a purchase order or lock these items on the purchase order so that we know…
  • How to enter Purchase order and create Sales Order using API

    My team has been using desktop Sage 100 (2021) to enter purchase orders to generate sales orders, but we would like to do this via API. https://help-sage100.na.sage.com/2021/FLOR/index.htm#Program_Listings/Program_Listings_Overview.htm?TocPath=Program…
  • 100E - Sage 100 - Object Interface Course Purchase Issue

    Hi, I purchased the above mentioned course on Sage university but I was not able to access the material as the payment was pending. Also, I got a auto mail from sage informing that one of their sales person will contact us for payment part, but I…
  • Setting shipping/mailing addresses in Sales Orders and Purchase Orders

    I feel like there's something I'm missing. I can successfully create a Sales Order and a Purchase Order with line items in Sage50 using the .NET API (not ODBC). The issue I'm having is that while the correct vendor/customer are set, the address for…
  • Creating a report for stock, purchasing and sales information

    Hi all, I have been asked by my boss if I can create a report that shows the following information: Stock Item Description On shelf quantity On purchase orders qty On sales orders qty Allocated Basically he…
  • Can an Inventory Depletion be Linked to the Receipt???

    First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…
  • 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.
  • Why and how to avoid: Orders input by other users not showing immediately.

    Problem We have several users who look after sales and purchasing who are in different offices. Often, one user will input e.g. a sale; however, other users cannot see this sale immediately which can result in the sale being input again by another user…
  • Converting Purchase Orders to Sales Orders

    Hi there apologies if these are an actual feature but I have done a bit of research and do not think they are. We use SAGE in our premises and I have a few ideas which I feel would improve it massively. The most pressing one being: the ability to…
  • Pop up memo when processing orders / Sales receipts / purchase orders etc

    if their is Customer / Supplier specific information that needs to be remembered by a user before processing - it would be really helpful when entering the account ref a popup window would open and show the specific information for that customer and supplier…
  • Sales Orders, Purchase Order Invoicing from stock codes

    On occasions if I need to find a stock code I then have to go back into the invoice. It may be a good idea to be able to then get an invoice link from the stock code to save then having to copy and paste, memorise or copy and paste the stock code to…
  • Open Purchase Order and Open Sales Order Report

    Good day, I need to a report from Sage Intelligence Reporting that wil show me in a flat excel document all purchase orders currently open and then seperately all Open Sales Orders. I can't seem to find this at all and our Demand driven inventory…
  • Visual Integrator - Purchase Order Detail - Unit of Measure Conversion Factor

    Recently was working on a large project to change the Standard Unit of Measure for thousands of SKUs in our company. The change necessitated that we change the thousands of open sales orders and purchase orders and work orders that were using these SKUs…
  • Purchase Order field in Sales Order Entry

    Hello all, I know that the "PO Number" field within Sales Order Entry is used for Auto-generating PO's from Sales Orders and creating drop ship PO's from a Sales Order, but I wanted to know if it has any other purpose? I wanted to use this field for…
  • Quantity Avaiable field

    Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…
  • Ship to customer on back to back inter company orders

    Hello All, We have a inter-company back to back setup for automatic creations of sales orders and purchase orders. That works fine but what I would like to do is to write Purchase Orders from one corporate site (PO Header - Corporate, for invoicing…
  • Inactive Products appearing on Sales & Purchase Orders

    I have made quite a few redundant products set as inactive - which was a great addition to v22. However, these inactive products still appear as available to enter on sales and purchase orders. If i try to order one of these products the system does…
  • How to get shortfall to show what is on PART order aswell?

    Hi, When creating Purchase Orders we are using the Shortfall feature. If there is a PART order it doesn't take this into account. E.g If I had a bottle which we had 0 free stock of and I just had an order come through for 5 of these, this becomes…
  • Back Order Fill Report (From posting a PO Receipt of Goods)

    The back order fill report included drop ship line items from sales orders. It would seem best to exclude drop ship as those lines will not be filled from the warehouse. Rich Garrett DSG, Inc.
  • I Need XML Template for purchase order and sales order import to sage 50

    Hi, I am using sage 50 application version 2017 and Peachwserver DLL version is 24.0 and Run time version is v4.0.30319. I am also using visual studio version 2013. My Sample Code: public static void Import(BOAccountSettings settings, Logger logger…