Build an Access Database for A/R

  • Estado: Closed
  • Premio: $110
  • Propuestas recibidas: 3
  • Ganador: blui88

Resumen del concurso

I need someone to build an access database for accounts receivable. I have a raw file that needs to be delivered in different forms based on different requirements. Reach out with questions. Thanks!

Edit: updated excel file has been attached.

Habilidades recomendadas

Comentarios del empleador

“Still waiting for the final file”

Imagen del perfil Dkuka, Bermuda.

Principales propuestas de este concurso

Ver más participaciones

Tablero Público de Clarificación

  • atawde65
    atawde65
    • 9 meses atrás

    Thanks for the updates data file. I have checked it and am able to create MS Access table to hold raw data and generate reports as per the tabs.

    • 9 meses atrás
  • blui88
    blui88
    • 9 meses atrás

    Hi there,
    Kindly share your thoughts about my efforts through entry # 15.
    Looking forward to hear more from you.
    Regards
    Santosh

    • 9 meses atrás
  • imfarrukh47
    imfarrukh47
    • 9 meses atrás

    in the aging classification row (on the summary tab) which dates are used?

    • 9 meses atrás
    1. imfarrukh47
      imfarrukh47
      • 9 meses atrás

      so meaning no data filter based on dates. just picking up a base on respective column data.
      dates shown below company name are just labels
      Am i right

      • 9 meses atrás
    2. imfarrukh47
      imfarrukh47
      • 9 meses atrás

      only filter is company name

      • 9 meses atrás
  • imfarrukh47
    imfarrukh47
    • 9 meses atrás

    What is Rc column (what is the source for this column) and will you add comments by yourself

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      RC can be empty, I can fix that. Comments can be manual

      • 9 meses atrás
  • imfarrukh47
    imfarrukh47
    • 9 meses atrás

    please review #14 Discussion required on summary report

    • 9 meses atrás
  • bishalali101
    bishalali101
    • 9 meses atrás

    Hello there!
    I have carefully gone through your job post and understood your requirements. I am offering you my quality service. You can check my profile & portfolio for details about my experiences. If you give me the opportunity, I’ll provide you quality service according to your instructions within your expected budget & estimated time. We can discuss it more over chat and also can show you my plans as well as previous work samples.I am waiting for your positive response. Thanks! Best Regards, Bishal Ali

    • 9 meses atrás
  • MMG2019
    MMG2019
    • 9 meses atrás

    hello,do you also want to design forms for raw tab and reports? or only import data from Excel file to Access database and get reports out of that?

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      design forms would be nice

      • 9 meses atrás
  • imfarrukh47
    imfarrukh47
    • 9 meses atrás

    how you get due date, there is no such date on raw data sheet

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      due date and settlement date is the same

      • 9 meses atrás
  • imfarrukh47
    imfarrukh47
    • 9 meses atrás

    1st) what are the criteria to filter related and unrelated data? note on both sheets is the same.
    2nd) How you will insert data in access (through excel import)?

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      to filter unrelated to related is the column "AG" in the raw data tab. if its "yes" that means its related, if its "no" that means is unrelated

      • 9 meses atrás
  • wissalekouki
    wissalekouki
    • 9 meses atrás

    the sheet "summary" is not really clear, what does represents the date "30/09/2019" ?

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      hi Wissal, feel free to change the 9.30.19 to current quarter. and 6.30.19 to prior quarter. when it comes out if database prior quarter should be empty

      • 9 meses atrás
  • wissalekouki
    wissalekouki
    • 9 meses atrás

    also, there is no company "A", "B" ... they are called company1 company 2 ...etc.

    • 9 meses atrás
    1. asifhakim
      asifhakim
      • 9 meses atrás

      give me chance to do this work, you will get great service from me.

      • 9 meses atrás
    2. Dkuka
      Organizador del concurso
      • 9 meses atrás

      Hi Wissal, they are the same, sorry for the naming convention

      • 9 meses atrás
  • imfarrukh47
    imfarrukh47
    • 9 meses atrás

    working on it donot close earlier

    • 9 meses atrás
  • pradeevenkat
    pradeevenkat
    • 9 meses atrás

    Hi there,
    I have few queries regarding the data .Could you please ping me in private chat to discuss further.
    Thanks,
    Pradeepa Venkataswamy

    • 9 meses atrás
  • asifhakim
    asifhakim
    • 9 meses atrás

    I am database expert person, having more then 10 year experience in software development.

    • 9 meses atrás
  • bishalali101
    bishalali101
    • 9 meses atrás

    Hello there!
    I have carefully gone through your job post and understood your requirements. I am offering you my quality service. You can check my profile & portfolio for details about my experiences. If you give me the opportunity, I’ll provide you quality service according to your instructions within your expected budget & estimated time. We can discuss it more over chat and also can show you my plans as well as previous work samples.I am waiting for your positive response. Thanks! Best Regards, Bishal Ali

    • 9 meses atrás
  • subirbbiswas0
    subirbbiswas0
    • 9 meses atrás

    Hi, 1. In the new file .. how do you differentiate between "related" and "unrelated" data from the raw data? 2. You said "Based on the different companies on the Raw Data tab, the classification will be separated in BA, MA, UK, SA".... can you please give an example of how the company information would look like in Raw Data tab?

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      the raw data tab is how the information looks. the rest of the tabs are the output that i want to get from access.

      • 9 meses atrás
  • blui88
    blui88
    • 9 meses atrás

    Hi,
    Attached file is corrupted.
    Kindly attach another copy.
    Thanks
    Santosh

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      Hi! Yes!

      • 9 meses atrás
    2. blui88
      blui88
      • 9 meses atrás

      Please open private chat window to response quickly, without disturbing to others.
      Thanks

      • 9 meses atrás
  • mandarvvaidya
    mandarvvaidya
    • 9 meses atrás

    I cannot open Data File.xlsx. Probably, Data File.xlsx is corrupt. Can you upload the file again?

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      updated file has been uploaded

      • 9 meses atrás
  • Singh0786
    Singh0786
    • 9 meses atrás

    Please upload attached file again.

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      updated file has been uploaded

      • 9 meses atrás
  • impawan29
    impawan29
    • 9 meses atrás

    Data file is corrupted.

    • 9 meses atrás
    1. Dkuka
      Organizador del concurso
      • 9 meses atrás

      updated file has been uploaded

      • 9 meses atrás
  • champakbiswas097
    champakbiswas097
    • 9 meses atrás

    can you come to my inbox ?

    • 9 meses atrás

Mostrar más comentarios

Cómo comenzar con los concursos

  • Publica tu concurso

    Publica tu concurso Fácil y rápido

  • Recibe montones de propuestas

    Consigue toneladas de propuestas De todo el mundo

  • Elige la mejor propuesta

    Elige la mejor propuesta ¡Descarga fácilmente los archivos!

Publica un concurso ahora o únete a nosotros hoy