Hi Bruce
Qty_DESPATCH is not in the list under the stock items and therefore does not recognize - can you help?
Neil
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Issues with Despatch Notes and Invoice Templates via email
-
meshsupplies
- User
- Posts: 20
- Joined: 07 Jun 2013, 11:47
- Sage Version: v2012 18 UK/Europe/Africa
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Issues with Despatch Notes and Invoice Templates via ema
You are looking in the wrong table
All the qtys are on the sop_item pop_items or inv_items tables depending on if this is a sales order_ invoice or purchase order
STOCK.QTY_ALLOCATED is the number of this stock code that have been allocated to orders as a whole it is a property of the stock item.
All the qtys are on the sop_item pop_items or inv_items tables depending on if this is a sales order_ invoice or purchase order
STOCK.QTY_ALLOCATED is the number of this stock code that have been allocated to orders as a whole it is a property of the stock item.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 2 guests