I am trying to get the delivery address *country* onto our delivery / invoice reports.
I can get the customer's country code, using COUNTRY_CODE.NAME, but this only gives me the customer registered address.
I currently show the delivery name and address (lines 1-5) using:-
INVOICE.DEL_NAME ...
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
Search found 8 matches
- 30 Sep 2016, 09:13
- Forum: Sage 50 Report Designer
- Topic: How to get delivery address *country* onto reports
- Replies: 2
- Views: 4385
- 27 Jan 2015, 19:37
- Forum: Sage 50 UK version General Help
- Topic: Can I import product BOMs ?
- Replies: 3
- Views: 3525
Re: Can I import product BOMs ?
What add-on would that be?
It might be worth investigating that option.
Cheers
It might be worth investigating that option.
Cheers
- 27 Jan 2015, 14:51
- Forum: Sage 50 UK version General Help
- Topic: Can I import product BOMs ?
- Replies: 3
- Views: 3525
Can I import product BOMs ?
We have Sage 50 Accounts Pro (v21.0.3.297) and I'm trying to set up some product BOMs.
We have maybe 20 products (each slight variations of each other) made up of about 15 items per product.
I know I can create the BOMs for each product manually, but I'd much rather save a *huge* amount of ...
We have maybe 20 products (each slight variations of each other) made up of about 15 items per product.
I know I can create the BOMs for each product manually, but I'd much rather save a *huge* amount of ...
- 03 Oct 2012, 12:26
- Forum: Sage 50 Report Designer
- Topic: Adding product web details to reports
- Replies: 1
- Views: 4138
Re: Adding product web details to reports
Fixed it ... finally !?!
In Data->Joins, I needed to change the link from SOP_ITEM to STOCK from an "Inner" to a "ParentOuter" join type.
Obvious, really ...
In Data->Joins, I needed to change the link from SOP_ITEM to STOCK from an "Inner" to a "ParentOuter" join type.
Obvious, really ...
- 03 Oct 2012, 11:53
- Forum: Sage 50 Report Designer
- Topic: Adding product web details to reports
- Replies: 1
- Views: 4138
Adding product web details to reports
The product description box is too limiting for us, and on this forum I found a hint about using the "web details" to add extra info for printing on reports.
I have added this to one of our reports (a tweaked version of the OrderAck layout) as an extra footer containing a variable box with the ...
I have added this to one of our reports (a tweaked version of the OrderAck layout) as an extra footer containing a variable box with the ...
- 29 Aug 2012, 14:37
- Forum: Sage 50 Report Designer
- Topic: Conditional formatting based on sum() totals
- Replies: 1
- Views: 5177
Conditional formatting based on sum() totals
I'm trying to hide / show a "Discount" header text box when a sales total discount is zero / non-zero.
I have a text box showing "Discount" and the conditional expression:-
if sum(Rounddp(SOP_ITEM.FOREIGN_FULL_NET_AMOUNT, 2) - Rounddp(SOP_ITEM.FOREIGN_NET_AMOUNT, 2) + Rounddp(SALES_ORDER.NET_VALUE ...
I have a text box showing "Discount" and the conditional expression:-
if sum(Rounddp(SOP_ITEM.FOREIGN_FULL_NET_AMOUNT, 2) - Rounddp(SOP_ITEM.FOREIGN_NET_AMOUNT, 2) + Rounddp(SALES_ORDER.NET_VALUE ...
- 17 Sep 2010, 08:22
- Forum: Sage 50 UK version General Help
- Topic: Can I add sop item comments to the gdn ?
- Replies: 12
- Views: 11593
Re: Can I add sop item comments to the gdn ?
If you want to track serial numbers then there are several third party addons that do it.
It's not the serial numbers I'm really interested in.
All I want to do is to have the comment fields shown on the gdn.
This doesn't seem too much to ask ... but it does appear to be not supported !?!
Am I ...
It's not the serial numbers I'm really interested in.
All I want to do is to have the comment fields shown on the gdn.
This doesn't seem too much to ask ... but it does appear to be not supported !?!
Am I ...
- 16 Sep 2010, 09:30
- Forum: Sage 50 UK version General Help
- Topic: Can I add sop item comments to the gdn ?
- Replies: 12
- Views: 11593
Can I add sop item comments to the gdn ?
Sage 50 Accounts Pro 2011
Each of our products has a serial number, and when shipping I'd like to have these serial numbers shown on the gdn.
I have already added the serial numbers into the comment fields of the sop item on the order, but I can't work out how to get the comments on the gdn. The ...
Each of our products has a serial number, and when shipping I'd like to have these serial numbers shown on the gdn.
I have already added the serial numbers into the comment fields of the sop item on the order, but I can't work out how to get the comments on the gdn. The ...