Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need Help
07-30-2015, 12:37 AM,
#1
Need Help
Hi i have done the installation & was loading items one by one, tried importing but was not going through, after that i have gone to phpmyadmin & imported parts data directly from .csv to stockmaster. however when i try to see the part in item it shows no record, when i search the part while entering Sales order it shows but while adding the part in sales order it shows item not present

can any one help me solution i can not delete all data & do new installation ( i had already entered lots of other data as well )


Attached Files
.pdf   web.pdf (Size: 424.28 KB / Downloads: 4)
Reply
07-30-2015, 11:15 AM,
#2
RE: Need Help
You could run the Z_MakeStockLocns.php script
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
07-30-2015, 03:03 PM,
#3
RE: Need Help
(07-30-2015, 11:15 AM)phil Wrote: You could run the Z_MakeStockLocns.php script

Thanks phil

now the error coming is
WARNING Message Report : The item code 2N3773G does not have a cost set up and order entry is set up to prohibit sales of items with no cost data entered

how do i fix this

Reply
07-30-2015, 07:43 PM,
#4
RE: Need Help
It would appear that you did not fill in a value for the materialcost (or any of the other cost fields) field of stockmaster when you imported the items. You can change the configuration to allow sales with zero costs (in Setup->Configuration Settings) but as an accountant I wouldn't advise it as you will end up with some odd accounting records.

Thanks
Tim
Reply
07-30-2015, 11:23 PM,
#5
RE: Need Help
(07-30-2015, 07:43 PM)falkoner Wrote: It would appear that you did not fill in a value for the materialcost (or any of the other cost fields) field of stockmaster when you imported the items. You can change the configuration to allow sales with zero costs (in Setup->Configuration Settings) but as an accountant I wouldn't advise it as you will end up with some odd accounting records.

Thanks
Tim

hi tim

thanks this issue is solved by allowing zero cost parts in SO

now i have created customer login & when trying to add SO below error is comming

Database Error 1452 : The order cannot be added because
Cannot add or update a child row: a foreign key constraint fails (`ecxsgs9y_webe384`.`salesorders`, CONSTRAINT `salesorders_ibfk_3` FOREIGN KEY (`fromstkloc`) REFERENCES `locations` (`loccode`))

Reply
08-13-2015, 09:37 PM,
#6
RE: Need Help
Interesting stuff guys.

volvo service
Reply
08-13-2015, 10:37 PM,
#7
RE: Need Help
Is the customer setup to allow access to the location? Do they have update permissions to that location?
Reply
08-13-2015, 11:56 PM,
#8
RE: Need Help
Hi Andrew this is an old thread the new post is just spam
Reply
08-14-2015, 12:12 AM,
#9
RE: Need Help
Tim,
Realized the post above mine was spam - didn't realize previous stuff was old or resolved. Hadn't seen it before.
Thanks.
Reply
08-14-2015, 01:09 PM,
#10
RE: Need Help
sorry guys - now ditched the spam
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)