Finance Module Development Help?

[Ndanileka]

Hi all, could you please assist with the below, I am currently working with a Dev team building an in-house system.
Pushing for a promotion

P1 P2 P3
30 Days Current Advance
All above periods are paid on the 1st Day of the 3rd Period, This represents cash flow at the start of Period 3
And not the actual expense of P1
The Final Figure is an aggregation of 3 months.
This is further complicated by the fact that we are reporting for 4 branches now;
How do we account for this accordingly on the System, without having to preparing multiple monthly payment Reports on excel for each branch?
How do we separate Monthly Expense and Monthly Cash flow?
Also note , purchase orders are only for C.O.Ds

Any idea how I could go about implementing this.

 

[Necropolis]

Get better developers?

And maybe a BA.

 

[Messugga]

Hi all, could you please assist with the below, I am currently working with a Dev team building an in-house system.
Pushing for a promotion

P1 P2 P3
30 Days Current Advance
All above periods are paid on the 1st Day of the 3rd Period, This represents cash flow at the start of Period 3
And not the actual expense of P1
The Final Figure is an aggregation of 3 months.
This is further complicated by the fact that we are reporting for 4 branches now;
How do we account for this accordingly on the System, without having to preparing multiple monthly payment Reports on excel for each branch?
How do we separate Monthly Expense and Monthly Cash flow?
Also note , purchase orders are only for C.O.Ds

Any idea how I could go about implementing this.

Holy crap that's vague. Are you asking people to advise you on how to implement something without having any context whatsoever about the rest of the architecture?

 

[Mr Scratch]

If this is for a real company, stop asking for advice on a forum and get yourself some competent developers. You are dealing with financials here, not your university homework.

 

[rward]

If this is for a real company, stop asking for advice on a forum and get yourself some competent developers. You are dealing with financials here, not your university homework.

yup, sounds like a homework assignment gone wrong.

Get someone that can write a proper requirement.

 

[Batista]

Wow, best not let your employer see this.

 

[skimread]

Hi all, could you please assist with the below, I am currently working with a Dev team building an in-house system.
Pushing for a promotion

P1 P2 P3
30 Days Current Advance
All above periods are paid on the 1st Day of the 3rd Period, This represents cash flow at the start of Period 3
And not the actual expense of P1
The Final Figure is an aggregation of 3 months.
This is further complicated by the fact that we are reporting for 4 branches now;
How do we account for this accordingly on the System, without having to preparing multiple monthly payment Reports on excel for each branch?
How do we separate Monthly Expense and Monthly Cash flow?
Also note , purchase orders are only for C.O.Ds

Any idea how I could go about implementing this.

It's not that hard.

 

[Ndanileka]

That's the thing, no else is getting it besides me, the complexity of system dev. Junior position with boundaries.
Our ERP system is bare, I just want to get something workable for our costing, 3 years in development and we are still using excel for most processes.
Lets say.. Tuck shop... exponential growth, with wrong person in financial management.
Company has massive potential though.
That's why I want to help sort things out.

 

[skimread]

That's the thing, no else is getting it besides me, the complexity of system dev. Junior position with boundaries.
Our ERP system is bare, I just want to get something workable for our costing, 3 years in development and we are still using excel for most processes.
Lets say.. Tuck shop... exponential growth, with wrong person in financial management.
Company has massive potential though.
That's why I want to help sort things out.

Did you say Tuck shop?

Are you at least going to pay whoever helps you with chocolates?

 

[skeptic_SA]

Decolonized IT FTW !

 

[Ndanileka]

I don't want "code", needed help with a logical structure.
This turning to something,
Thanks for your comments everyone.

 

[rward]

After reading it properly, the initial post is about as useful as

I have 2 walls and a window.
15 twigs make an igloo
My camera takes a 32gig SD card.
Build me a tractor from the spares.

 

[Hamster]

Decolonized IT FTW !

LOOOOOOOOL

 

[rward]

Any idea how I could go about implementing this.

Ok - more seriously. Remember all that stuff you may have learnt about needing good communication and writing skills?
This is where it starts to show.

Your initial post is ****. You need to be clearer on what is required and what you have:

> P1 P2 P3
> 30 Days Current Advance
> All above periods are paid on the 1st Day of the 3rd Period, This represents cash flow at the start of Period 3
> And not the actual expense of P1

Are those 2 sentences supposed to be joined and making a newlin and capitalising "And" at the start of the second line is a mistake?

> The Final Figure is an aggregation of 3 months.

what is this "Final Figure" you are talking about - it has not been introduced before. Is it the total amount to be paid or the cash flow or something else?

> This is further complicated by the fact that we are reporting for 4 branches now;
If you're working out a database then shouldn't this be solved with a "branch" column?

> How do we account for this accordingly on the System, without having to preparing multiple monthly payment Reports on excel for each branch?

Are payment made per branch or do you make a payment that covers all branches?


> How do we separate Monthly Expense and Monthly Cash flow?
You are not providing any input as to what information you are capturing.
We cannot determine how you would seperate expenses and cash flow without knowing what you are capturing and how.

> Also note , purchase orders are only for C.O.Ds

What relevance does this have?
How are purchase orders captured?

You need to explain more.

 

[skimread]

I am currently working with a Dev team building an in-house system.

Are you the business analyst for the dev team?

 

[reactor_sa]

Basic financial statements, if anyone in your team has any real finance experience, these requirements will be piss.

 

[Messugga]

Ok - more seriously. Remember all that stuff you may have learnt about needing good communication and writing skills?
This is where it starts to show.

Your initial post is ****. You need to be clearer on what is required and what you have:

> P1 P2 P3
> 30 Days Current Advance
> All above periods are paid on the 1st Day of the 3rd Period, This represents cash flow at the start of Period 3
> And not the actual expense of P1

Are those 2 sentences supposed to be joined and making a newlin and capitalising "And" at the start of the second line is a mistake?

> The Final Figure is an aggregation of 3 months.

what is this "Final Figure" you are talking about - it has not been introduced before. Is it the total amount to be paid or the cash flow or something else?

> This is further complicated by the fact that we are reporting for 4 branches now;
If you're working out a database then shouldn't this be solved with a "branch" column?

> How do we account for this accordingly on the System, without having to preparing multiple monthly payment Reports on excel for each branch?

Are payment made per branch or do you make a payment that covers all branches?


> How do we separate Monthly Expense and Monthly Cash flow?
You are not providing any input as to what information you are capturing.
We cannot determine how you would seperate expenses and cash flow without knowing what you are capturing and how.

> Also note , purchase orders are only for C.O.Ds

What relevance does this have?
How are purchase orders captured?

You need to explain more.

To me, it seems fairly obvious that OP simply copied the content of an email and pasted it here. Zero effort was taken to explain context, etc.

There's a reason he's a junior developer (Hint: it's because he doesn't know any better).

 

[rward]

To me, it seems fairly obvious that OP simply copied the content of an email and pasted it here. Zero effort was taken to explain context, etc.

Agreed.
Hopefully the post will help illustrate that copy and pasting without thinking makes more work than before.

I hope Ndanileka does reply and everyones time isn't wasted here..

 

[Hamish McPanji]

It's not that hard.

View attachment 401041

There are 2 errors there that were very easy to spot. On the 3rd line, the 2nd "-" is meant to be a "+" . And on the fourth line , the 3rd "+" is meant to be a "-".

Common and very amateurish mistakes to make actually