I Got Problem With Report Monthly Sale Vs Purchase

0

Hello support,

I have just realize that the system is giving error report on monthly sale and purchase, --> it projects the same result (as my attached screenshot)

the popup result of each month of report monthly purchase and monthly sale just same number.

note: i have updated to the latest version already V3.5.3 but problem still not solved.

please check and help

Question Resolved For: Stock Manager Advance with All Modules 0 Votes 28 Answers 794 Views
Asked by Prom Vongchann 6 months ago

0

Answered by Mian Saleem 6 months ago

Hello,

Both screenshot are for May 2024 Are you saying that if you click on any other month name but it is showing May? Or Am I missed something? 😦

0

Answered by Prom Vongchann 6 months ago

Mian Saleem same even other month.

for reference i will send you another month result for March

0

Answered by Prom Vongchann 5 months ago

Mian Saleem Hello support,

do you have any idea?

0

Answered by Mian Saleem 5 months ago

Hello,

The issue is due to AVCO. Are you using the AVCO method? Please use FIFO or LIFO instead AVCO and inventory accounting method should not be changed but if need only at the start of month before adding any sale.

Thank you

0

Answered by Prom Vongchann 5 months ago

Mian Saleem oh so that means for the purchase and sale report is not correct when using AVCO? now I am using AVCO.

I also have another issue and I doubt it might be AVCO also maybe, the story is like this

I have item A = 20 pcs in stock
when i transfer item A from warehouse 01 to warehouse 02 = 10pcs ( not allow )
but i tried to change number of qty to transfer it can put 2pcs to transfer and i do transfer 5 times ( it allowed)

this case, what do you think it is the cause of this problem?

0

Answered by Mian Saleem 5 months ago

Hello,

AVCO can have cost issues like negative cost for some products. It is not related to stock/quantity.

The transfer quantity is very strange, you can transfer same quantity in smaller chunks but can't at once. Can I have site details to have a look at this?

Thank you

0

Answered by Prom Vongchann 5 months ago

Mian Saleem Hello, do you want to have my website admin access or you want my hosting access ?

0

Answered by Mian Saleem 5 months ago

Hello,

Only SMA access with product code to check transfer.

Thank you

0

Answered by Prom Vongchann 5 months ago

yes your test is correct, and I also did the same way.
but the problem is some items, HDD 10TB before it has more than 20units but we can only transfer 10units if we put 11 it will not proceed, since now we sole most of them so the qty is less than 10units that is why you don't see the problem of the transfer.

give me few days for the test on other item, and if this problem occur i will drop item code for you to test.

thanks

0

Answered by Prom Vongchann 4 months ago

Mian Saleem I am not sure what happen or it is about your system but i see that in return sale invoice all return in a month is having all the same sale return refference number ( can check my attached about database )

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.