Hi Pedro,
I followed you advice according the sales synchronization this post;
"Glad to see you are almost done, If it is already syncing products, taxes, customers data and not the sales, you might have issues with the ERP configuration (accounting period closed, or similar issue), please analyze the ERP logs and look for warning or errors , usually they are very descriptive (/tmp/adempiere.log)
I found the following error;
ERROR: insert or update on table "c_order" violates foreign key constraint "cpaymentterm_soheader"
Detail: Key (c_paymentterm_id)=(1000001) is not present in table "c_paymentterm".; State=23503; ErrorCode=0
What I did is ; to set the payment term in the messages window to Immediate
The result is that the sales synchronization succeeded well and it appeared on SmartERP once it happened on SmartPOS.
The issue is that whether the sales transaction on POS is by cash, credit card, coupon...etc, it appeared in the sales order in the ERP only as 'On Credit' payment rule and 'immediate' payment type. I assume that the payment rule should be according the sales type used in POS. eg; when the sales transaction is cash on POS, the payment rule in ERP for this order should be cash.
Did I do something wrong related the Messages on ERP, or this is case in SmartERP. However this is not what happened with Adempiere.
Thanks for your help
Kalo Wand
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Pedro,
Do I consider the previous issue is the default scenario of SmartERP and SmartPOS? although, I assume this is not right from business prospective.
Or Did I do something wrong?
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Your tests seem to be correct, but I have not had time to analyze the topic with the required detail ... it might be a default behaviuor as you mention or a bug (missing functionality) ... due to the required time to test and replicate and because our current tasks you might have to wait until the next week for some preliminary feedback ... engage our priority services (infosmart@smartjsp.com) or try to fix it yourself.
Regards
Pedro R.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for your reply.
I just wonder how you couldn't notice this issue in the resturants chain where u implemented SmartPOS, as I considered this point as critical in the cycle and have big impact on business
Anyhow I'll follow your advice related waiting till next week.
BTW there is another point I'll create a new topic for it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Pedro,
I followed you advice according the sales synchronization this post;
"Glad to see you are almost done, If it is already syncing products, taxes, customers data and not the sales, you might have issues with the ERP configuration (accounting period closed, or similar issue), please analyze the ERP logs and look for warning or errors , usually they are very descriptive (/tmp/adempiere.log)
I found the following error;
ERROR: insert or update on table "c_order" violates foreign key constraint "cpaymentterm_soheader"
Detail: Key (c_paymentterm_id)=(1000001) is not present in table "c_paymentterm".; State=23503; ErrorCode=0
What I did is ; to set the payment term in the messages window to Immediate
The result is that the sales synchronization succeeded well and it appeared on SmartERP once it happened on SmartPOS.
The issue is that whether the sales transaction on POS is by cash, credit card, coupon...etc, it appeared in the sales order in the ERP only as 'On Credit' payment rule and 'immediate' payment type. I assume that the payment rule should be according the sales type used in POS. eg; when the sales transaction is cash on POS, the payment rule in ERP for this order should be cash.
Did I do something wrong related the Messages on ERP, or this is case in SmartERP. However this is not what happened with Adempiere.
Thanks for your help
Kalo Wand
Hi Pedro,
Is there any feedback. I appreciate your help.
thanks
Kalo wand
Hi Pedro,
Do I consider the previous issue is the default scenario of SmartERP and SmartPOS? although, I assume this is not right from business prospective.
Or Did I do something wrong?
Thanks
Hi Kalo,
Your tests seem to be correct, but I have not had time to analyze the topic with the required detail ... it might be a default behaviuor as you mention or a bug (missing functionality) ... due to the required time to test and replicate and because our current tasks you might have to wait until the next week for some preliminary feedback ... engage our priority services (infosmart@smartjsp.com) or try to fix it yourself.
Regards
Pedro R.
Thanks for your reply.
I just wonder how you couldn't notice this issue in the resturants chain where u implemented SmartPOS, as I considered this point as critical in the cycle and have big impact on business
Anyhow I'll follow your advice related waiting till next week.
BTW there is another point I'll create a new topic for it.