UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Code For New Trade Allocation Qty, Access 2007    
 
   
esugiawan
post Feb 26 2018, 09:42 PM
Post#1



Posts: 3
Joined: 26-February 18



I have 1 customer with trade more than 1 item , like this
Attached File  tradedetail.JPG ( 29.9K )Number of downloads: 3


at the end of day, customer, want to split that transaction into several customer , from MI to MIa, Mib, MIc , with same avg price and amount ,only difference qty , like this
Attached File  tradeallocation.JPG ( 34.47K )Number of downloads: 2


and i should get a result report like this
Attached File  NewTD.JPG ( 37.34K )Number of downloads: 1


right now i got that report with manually using ms.excel solver ,after validating the average price ,amount and quantity

my question is , how to get automaticly with ms.access , can you give me a guide or maybe some code to solve this probrem

thx
Go to the top of the page
 
GroverParkGeorge
post Feb 27 2018, 06:39 AM
Post#2


UA Admin
Posts: 32,821
Joined: 20-June 02
From: Newcastle, WA


How do you determine the customers for the allocation? Are they always the same three customers? Or can the number vary? Or will it be different customers on different days?

--------------------
Go to the top of the page
 
esugiawan
post Feb 27 2018, 09:02 PM
Post#3



Posts: 3
Joined: 26-February 18



at below only for example ,

real process like this
1. main dealer will be transaction buy/sell stock item everyday ( item can vary )
2. at the end of day, I send Trade Detail ( excel ) by email to dealer
3. dealer will be split Trade Detail into several customer ( number can vary ) --Trade Allocation and dealer will be send email to me
4. I split manually trade detail into Trade Allocation one by one using solver ms.excel

thats i do everyday

note between Trade detail and after i split Trade detail allocation , will be difference amount can be tolerance ( -1 until 1) because using average price

Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    21st June 2018 - 08:49 PM