Browse By Tags

Hi All! I'm trying to edit our purchase orders so that it works with both types of orders we do. Sometimes we don't add a code for items we're ordering in on a one off basis and we just use the S1 - Special Item code. When using STOCK.SUPPLIER_PART_NUMBER…

I'm trying to add a data field with the information from this in the item line of the products description . I cannot find what data field I need for this Some please, please help.

Further to my earlier post about conditional formatting. I now need to change it slightly and use a different field, but also to have 3 colours instead. I will see if I can explain it. I have butchered a copy of the Purchase Orders and Returns report…

I'm trying to build a report that includes each stock item's next purchase order delivery requested date. So I'm trying to create a SQL view ideally returning ItemID NextRequestedDeliveryDate (Purchase Order) DocumentNo. I'll then add the…

I've been using the Purchase Analysis intelligence report, however I want to add the "Purchase Order No." (not JobID) in the report. Sage has to be storing it somewhere, because we fill it out on every PO we input, same with "Unit Price". It is not…

I am designing a Purchase Order so it includes 'Web Details' after an POP.ITEM for products that have more description. I have added a new group header/footer as POP_ITEM.ITEM_NUMBER and tweaked the join from 'Inner' to 'Parent Outer' and this seems…