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 ...
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: 5925
- 21 Mar 2019, 13:57
- Forum: Sage 50 Report Designer
- Topic: BOM Issue
- Replies: 3
- Views: 5925
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 of ...
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 of ...
- 04 Jan 2019, 23:26
- Forum: Sage 50 Report Designer
- Topic: Expression Editor (Replace)
- Replies: 1
- Views: 3905
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.NOTES ...
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.NOTES ...
- 07 Apr 2018, 15:53
- Forum: Sage 50 Report Designer
- Topic: Compnent Code Duplicating
- Replies: 2
- Views: 4169
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: 4169
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 ...
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 ...
- 06 Apr 2018, 13:01
- Forum: Sage 50 Report Designer
- Topic: Sage 50 Report Designer Help
- Replies: 6
- Views: 6437
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: 6437
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 ...
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 ...
- 20 Mar 2018, 13:28
- Forum: Sage 50 Report Designer
- Topic: BOM
- Replies: 1
- Views: 3144
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 ...
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 ...
- 16 Feb 2018, 22:15
- Forum: Sage 50 Report Designer
- Topic: Sage 50 Report Designer Help
- Replies: 6
- Views: 6437
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 add ...
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 add ...