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 9 matches
- 25 Mar 2019, 13:35
- Forum: Sage 50 Report Designer
- Topic: BOM Issue
- Replies: 3
- Views: 3987
Re: BOM Issue
Hi Bruce. I have attached 2 sage reports Sage Report 1 - This report doesn't pull through the stock code (for the product that has BOM attached) Sage Report 2 - This report does pull through the stock code (but it pulls it through twice) this is only affecting products that have BOM attached to them...
- 21 Mar 2019, 13:57
- Forum: Sage 50 Report Designer
- Topic: BOM Issue
- Replies: 3
- Views: 3987
BOM Issue
Hi I have a product that has BOM on it when it pulls through to 1 of my reports its pulling through a duplicate line of the same item. On the order number Header, the filter I'm using is STOCK.HAS_NO_COMPONENT = 0 AND STOCK.HAS_BOM = "" which is working as if I remove it I get a duplicate ...
- 04 Jan 2019, 23:26
- Forum: Sage 50 Report Designer
- Topic: Expression Editor (Replace)
- Replies: 1
- Views: 3279
Expression Editor (Replace)
Hi All Wondering if someone can help, I am trying to use the replace function in the expression editor. I have all the replace data correct but I'm not 100% sure how to format the expression. Currently, the expression is SALES_ORDER.NOTES_3 = "" ? SALES_LEDGER.COUNTRY_CODE : SALES_ORDER.NO...
- 07 Apr 2018, 15:53
- Forum: Sage 50 Report Designer
- Topic: Compnent Code Duplicating
- Replies: 2
- Views: 3297
Re: Compnent Code Duplicating
Hi Bruce
I figured out the issue I had to add an extra filter onto the details section.
Thank you for all your help
I figured out the issue I had to add an extra filter onto the details section.
Thank you for all your help
- 06 Apr 2018, 19:48
- Forum: Sage 50 Report Designer
- Topic: Compnent Code Duplicating
- Replies: 2
- Views: 3297
Compnent Code Duplicating
Hi I have a report I have pretty much got in all working apart from one product keeps pulling as a duplicate and I'm not sure why it is part of a BOM all other BOM on different products pull through without them being duplicates. I have 2 sections Header and Details The Header Filter is: STOCK.HAS_N...
- 06 Apr 2018, 13:01
- Forum: Sage 50 Report Designer
- Topic: Sage 50 Report Designer Help
- Replies: 6
- Views: 5207
Re: Sage 50 Report Designer Help
Hi Bruce
That worked thank you so much.
Christina
That worked thank you so much.
Christina
- 05 Apr 2018, 21:52
- Forum: Sage 50 Report Designer
- Topic: Sage 50 Report Designer Help
- Replies: 6
- Views: 5207
Re: Sage 50 Report Designer Help
Hi Bruce Thank you for this, this does work so all the spaces no longer pull through but I'm wondering if you can put 2 replace strings in the same variable. I have tried it a few ways and can't seem to get it working but not sure if Im inputting it incorrectly. Please see below what im trying to do...
- 20 Mar 2018, 13:28
- Forum: Sage 50 Report Designer
- Topic: BOM
- Replies: 1
- Views: 2628
BOM
Hi I need to find a way to show the bill of materials in a report so it shows the child items not the parent items I have the below but then it shows anything without a BOM as 0 quantity and is also showing only 1 item on the BOM and not the 2 as it should be. STOCK.HAS_NO_COMPONENT = 1 ? INVOICE_IT...
- 16 Feb 2018, 22:15
- Forum: Sage 50 Report Designer
- Topic: Sage 50 Report Designer Help
- Replies: 6
- Views: 5207
Sage 50 Report Designer Help
Hi All, Wondering if someone can help. I have finished of most of my Sage report but I'm struggling with 2 statements (Any help would be amazing) 1st Statement Issue: So far I have INVOICE.DEL_NAME LIKE "" ? INVOICE.ADDRESS_1: INVOICE.DEL_ADDRESS_1 which is working fine but I also need to ...